<?php
/**
* Load the details of a given transaction ID
*
* @author       Fabrice Douteaud <clearbudget@douteaud.com>
* @package      actions
* @access       public
*/

/***********************************************************************

  Copyright (C) 2008  Fabrice douteaud (clearbudget@douteaud.com)

    This file is part of ClearBudget.

    ClearBudget is free software: you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation, either version 3 of the License, or
    (at your option) any later version.

    ClearBudget is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License
    along with ClearBudget.  If not, see <http://www.gnu.org/licenses/>.


************************************************************************/
//prevent direct access
if(!defined('ENGINEON')) die('Direct access forbidden');

$db = class_db::getInstance();
$transactionId = $context->id;

// get all the categories but the 'uncategorized' one
$db->addFields('id');
$db->addFields('name');
$db->addWhere('id', '!=', '1');
// execute
$db->select('v_categories');
while(($item = $db->fetchRow()) !== false) {
  $categories[$item['id']] = $item['name'];
  }
// setup the query
$db->addFields('id');
$db->addFields('operationDate');
$db->addFields('category');
$db->addFields('categoryName');
$db->addFields('amount');
$db->addFields('debit');
$db->addFields('payee');
$db->addFields('memo');
$db->addFields('comments');
$db->addWhere('id', '=', $transactionId);
$count = $db->select('v_items', true);
$result = $db->fetchRow();

?>